package com.wx.dao;

import com.wx.pojo.Member;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;

/**
 * 会员管理
 */
public interface MemberDao {
    /**
     * 依据身份证查询
     */
    @Select("SELECT * FROM `t_member` WHERE  idCard=#{id}")
    Member findMemberByIdCard(String idCard);

    @Insert("INSERT INTO `t_member` VALUES (#{id},#{fileNumber}, #{name}, #{sex}, #{idCard}, #{phoneNumber}, #{regTime}, #{password}, #{email}, #{birthday}, #{remark})")
    void addMember(Member member);
}
